CREATE TABLE jms_dm.dm_sqs_abnomal_problem_cnt_dt (
                                                      reg_network_mr_code varchar(50) NULL COMMENT "登记网点大区code",
                                                      reg_network_proxy_code varchar(50) NULL COMMENT "登记网点代理区code",
                                                      second_level_type_code varchar(50) NULL COMMENT "二级问题件类型code",
                                                      date_time date NULL COMMENT "登记日期",
                                                      registration_network_code varchar(50) NULL COMMENT "登记网点code",
                                                      registration_network_name varchar(120) NULL COMMENT "登记网点name",
                                                      reg_network_mr_name varchar(120) NULL COMMENT "登记网点大区name",
                                                      reg_network_proxy_name varchar(120) NULL COMMENT "登记网点代理区name",
                                                      proble_type_subject_code varchar(50) NULL COMMENT "一级问题件类型code",
                                                      proble_type_subject_name varchar(120) NULL COMMENT "一级级问题件类型name",
                                                      second_level_type_name varchar(120) NULL COMMENT "二级问题件类型name",
                                                      order_source_name varchar(120) NULL COMMENT "订单来源",
                                                      in_out_bound int(11) NULL COMMENT "进出港字段 1 进港 2 出港",
                                                      problem_cnt int(11) NULL COMMENT "问题件件量",
                                                      reported_cnt int(11) NULL COMMENT "已报备票数",
                                                      abnomal_cnt int(11) NULL COMMENT "异常票数",
                                                      before_problem_cnt int(11) NULL COMMENT "问题件前超时效催件",
                                                      after_problem_cnt int(11) NULL COMMENT "问题件后超时效催件",
                                                      cnt_type int(11) NULL COMMENT "统计类型1不可抗力2有到未发",
                                                      reg_fran_code varchar(80) NULL COMMENT "登记网点加盟商code",
                                                      reg_fran_name varchar(80) NULL COMMENT "登记网点加盟商name",
                                                      network_type int(11) NULL COMMENT "网点类型 4中心5集散6网点"
) ENGINE=OLAP
DUPLICATE KEY(reg_network_mr_code, reg_network_proxy_code, second_level_type_code)
COMMENT "异常问题件监控汇总"
PARTITION BY RANGE(date_time)
(START ("2023-10-01") END ("2023-12-22") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(registration_network_code) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2",
"enable_persistent_index" = "false"
);